CREATE TABLE [dbo].[Product](
	[ProductId] [int] IDENTITY(1,1) NOT NULL,
	[ProductNameRu] [nvarchar](500) NOT NULL,
	[ProductNameEn] [nvarchar](500) NOT NULL,
	[ProductDescRu] [nvarchar](max) NULL,
	[ProductDescEn] [nvarchar](max) NULL,
	[PreviewImage] [varchar](500) NULL,
	[MainImage] [varchar](500) NULL,
	[Price] [int] NOT NULL,
	[IsShow] [bit] NOT NULL,
	[OutStock] [bit] NOT NULL,
 CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED 
(
	[ProductId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_Price]  DEFAULT ((0)) FOR [Price]
GO

ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_IsShow]  DEFAULT ((1)) FOR [IsShow]
GO

ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_OutStock]  DEFAULT ((0)) FOR [OutStock]
GO


